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')

select distinct city from station where city REGEXP '^[aeiou]'; even this works;

And for oracle:

SELECT DISTINCT city FROM station WHERE REGEXP_LIKE(city, '^[A,E,I,O,U]');

hi, please what is the function of ^ before [aeiou] and .* as well?

what is this regexp?

"^[aeiou]" this is enough

SELECT DISTINCT city FROM station WHERE REGEXP_LIKE (city,'^(A|E|I|O|U)');

It worked for me. Why have you used period. Please help me figure it out.

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]%'

When I ran this it failed with the following error:

"Msg 105, Level 15, State 1, Server WIN-ILO9GLLB9J0, Line 2 Unclosed quotation mark after the character string '[a, e, i, o, u]%; go '. Msg 102, Level 15, State 1, Server WIN-ILO9GLLB9J0, Line 2 Incorrect syntax near '[a, e, i, o, u]%; go '. "

However, it worked when I ran:

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%';

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

can u post the postgres solution to this?

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??

I learned something new today. Thanx for sharing