SELECT id, name, parent FROM villa_loc WHERE name LIKE 'Biarritz' OR name LIKE 'Biarritz-Cote dAzur' OR name LIKE 'Biarritz area' OR name LIKE 'Biarritz city' OR name LIKE 'Biarritz coast' OR name LIKE 'Biarritz island'