mySQL wildcards

Out of context: Reply #1

• Started
• Last post
• 7 Responses

• traffic_light0

  SELECT CONCAT(last_name,', ',first_name) AS full_name
  FROM mytable WHERE fullname like '%john%smith%'

  That's a start. The % is a wildcard in mysql.com

  traffic_light 0Permalink

  UpvoteDownvote

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel

View thread