SQL Scripts "LIKE" Statement? need help

unamas

hi,

Good day!

Anyone generous enough to help me with this query. Anyway,

I have a random acount number of 1, 2, 3, 4, 5 and i wanna get the results after this number in a table.

Select * from table where account like ('1%','2%', '3%','4%','5%')

is this select query possible or not? or there are other method which you can recommend. thank you.

regards,

Unamas

ronverdonk

No, this format is not possible. But I would prefer the following:

Expand|Select|Wrap|Line Numbers

SELECT * FROM table where SUBSTRING(account,1,1) BETWEEN 1 AND 5

Ronald :cool:

SQL Scripts "LIKE" Statement? need help

re: SQL Scripts "LIKE" Statement? need help

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about