5 Useful MySQL Functions And Control Flows

Tutorials Shared by the Internet Community

Advertisements


Synopsis

If statements have been a life saver on many occasions. They are invaluable for checking a value.

Statistics

  • Total Hits - 23350

  • Total Votes - 111 votes

  • Vote Up - 50 votes

  • Vote Down - 61 votes

  • Domain - www.talkphp.com

  • Category - MySQL/MySQL Misc

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 01:30:11

Description

This will return any strings that begin with W and end in Y. Wildhoney, for instance, will be brought back, but TalkPHP would not. MySQL's REGEXP is case-insensitive and you may also use NOT REGEXP to reverse the outcome. In the above example using NOT REGEXP would return everyone but members that do not begin with W and end in Y. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements