It is not working!

what is the REGEXP portion?

Can you tell me how this querry would be modified if the question is IF the cities name END with 'aeiou'.

I had the same idea:

SELECT DISTINCT city FROM station

WHERE left(city,1) REGEXP '[aeiou]'

THANKS..IT'S WORKING...

tanq bro its workig

Awesome!

Its advised to avoid regular expressions in queries. You can use substr for same:

select distinct city from station where substr(city, 1, 1) in ('a', 'e', 'i', 'o', 'u');

what is regular expression where i can read about it

explain REGEXP "^[aeiou].*" and REGEXP"[aeiou]$"

try this query in ORACLE

SELECT DISTINCT city FROM station WHERE city LIKE 'A%' or city LIKE 'E%' or city LIKE 'I%' or city LIKE 'O%' or city LIKE 'U%';

this is the most simple code that every one can understand, very easy and straight forward

select distinct city from station where Lower(city) LiKE 'a%' or lower(city) LIKE 'e%' or lower(city) LIKE 'i%' or lower (city) LIKE 'o%' or lower (city) LIKE 'u%';

oh I did it the hard way using or and checking it for each and every vowel. i learnt a new thing

use

select distinct city from station where city rlike '^(a|e|i|o|u).*' order by city;

Can you please explain why you put * at the end?

Why doesnt it work for Oracle?

what is REGEXP ?

This is working on mysql....but not sqlserver.....can u plz do it on sqlserver.....as I am using sqlserver plateform...

Thanks it works fine . Can anybody help me in figuring out the error in

select city from station where city like '^[aeiou]';

select city from station where substring(city,1,1) in ('a','e','i','o','u');

Mysql

use RLIKE '^[aeiouAEIOU].*' insted of REGEXP

SELECT DISTINCT city FROM station WHERE city REGEXP "^[aeiou]";

This is enough. Why .*

[MySQL] SELECT DISTINCT city FROM station WHERE city REGEXP '^[aeiou]';

regexp '^[aeiou]'; ^ stands for 1st alphabet.

I think that becomes a greedy search. So probably this is sufficient:

   SELECT DISTINCT city FROM STATION WHERE city RLIKE '^[aeiou]';

SELECT CITY FROM STATION WHERE CITY REGEXP '^[aeiouAEIOU].*';

How would this differ if using MS SQL Server?

SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE (CITY, '^[AEIOU]');

its not working.

this is working fine with mysql ,and use in that only

It is working well.

ееееее бой

Simple Solution for ORACLE SQL.

SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE (CITY, '^[AEIOU].*', 'c');

this works

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[aeiou].*$';

its working

please give me a explanation for REGEXP "^[aeiou].*";

Use:- SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE 'a%' or CITY LIKE 'e%'or CITY LIKE 'i%'or CITY LIKE 'o%' or CITY LIKE 'u%'

what is "." represeent here?

SELECT DISTINCT city FROM station WHERE city REGEXP "^[aeiou].*";

Why is the "^" "*" used in the above query?

We don't need to put .* to have the solution.

SELECT DISTINCT CITY FROM STATION WHERE CITY RLIKE '^[a,e,i,o,u]'; works as well

Try this on mysql: SELECT DISTINCT(CITY) FROM STATION WHERE CITY REGEXP "^[AEIOU].*";

Of course, I should have thought of regex. Thanks for that! I solved it with the more clumsy:

SELECT DISTINCT(city) FROM station WHERE left(city, 1) IN ('a','e','i','o','u')

I added a distinct()

select distinct(city) from station where lower(substr(city,1,1)) in ('a','e','i','o','u');

why we use lower in code

yes its work greate!!!

Its a SQL query in ANSI syntax, so it will work in all DBMS that follows ANSI, no matter being Oracle or mysql. I have compiled with mysql version as:

select distinct city from station where substr(city, 1, 1) in ('a', 'e', 'i', 'o', 'u');

why u use ORDER BY city;??

this not working for me

----MY SQL SERVER---

select CITY from STATION where CITY LIKE '[aeiouAEIOU]%' group by CITY;

Your query is not giving any output.

SELECT CITY FROM STATION WHERE LEFT(CITY,1) IN ('a','e','i','o','u') GROUP BY CITY

use REGEXP '^[aeiou]' it will select the citynames those which are starting with vowels regexp means it is similar to like operator and defined as regular expresion "^" - this symbol indicates starting. check select distinct city from station where city REGEXP '^[aeiou]' :)

wrong answer

Using MYSQL

SELECT DISTINCT city FROM station WHERE SUBSTR(CITY,1,1) IN ('A','E','I','O','U');

Why the same query does not work in oracle?

Thanks! The following works too SELECT DISTINCT city from station where city LIKE '[aeiou]%'

Agreed, I was trying to do this in postgres...

Sir, 1.) What does REGEXP_LIKE do?

2.) And why can't we use -->

SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE 'A%' OR CITY LIKE 'E%' OR CITY LIKE 'I%' OR CITY LIKE 'O%' OR CITY LIKE 'U%';

what for "^" this symbol is used and how does it works??

You can also do by using substring method

SELECT CITY FROM STATION WHERE SUBSTRING(CITY,1,1) IN ('A','E','I','O','U')

This works for MySQL Server

hello.please explain your code.what's the use of regexp and why you wrote upper keyword in that.please

i didnt understand how did your query worked please explain