467,149 Members | 1,297 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,149 developers. It's quick & easy.

About where clause

Parul Bagadia
Hello ppl, m new in SQL programing, in one of the assignments; we have to select guest_name from the guests table who all stay in PUNE, but the thing is m taking complete address of that person; and in that address somewhere city will be mentioned.
So is it possible in SQL that attribute will get selected just because of one word from the complete address?
Sep 15 '08 #1
  • viewed: 853
1 Reply
Expert 512MB
You can try this:

Expand|Select|Wrap|Line Numbers
  1. address like '%city%'
Good luck.
Sep 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Michael | last post: by
3 posts views Thread by Chris | last post: by
4 posts views Thread by Henri | last post: by
7 posts views Thread by Comagmbh@gmx.de | last post: by
5 posts views Thread by pwiegers@gmail.com | last post: by
3 posts views Thread by Rahul Babbar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.