5 Useful MySQL Functions And Control Flows

Tutorials Shared by the Internet Community


  Top Tutorials     New Tutorials     Submit     Login     Register  

5 Useful MySQL Functions And Control Flows

If statements have been a life saver on many occasions. They are invaluable for checking a value.
  • Total Hits: 22436

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating


  • Total Votes: 155 votes

  • Category: MySQL/MySQL Misc

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

  • Submitted By: Shekhar

  • Set as Favorite


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.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 36.13%  56
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.97%  17
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 12.26%  19
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.61%  18
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 29.03%  45

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.