Jump to content


Photo

LIKE and WHERE in the same line


  • Please log in to reply
2 replies to this topic

#1 Uranium-235

Uranium-235
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 16 January 2003 - 06:27 AM

how can I do this? like

SELECT * FROM foobar WHERE f=3 AND LIKE X=\'%FOO%\'

that obviousely dosen\'t work. how can I get this to work?
Random Quote:[br][br][url=http://www.paintbug.com/scripts/quote_source.phps]

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 16 January 2003 - 06:41 AM

SELECT * FROM foobar WHERE f=3 AND X LIKE \'%FOO%\'
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 Uranium-235

Uranium-235
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 16 January 2003 - 06:56 AM

/boards the shortbus

thanks :)
Random Quote:[br][br][url=http://www.paintbug.com/scripts/quote_source.phps]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users