Search Query

Hi... I have a RDS Aurora MySQL data base and I’m trying to run a simple query search:

SELECT * FROM event WHERE ev_eventid LIKE `ev9062555368`

But Im receiving the following error message: 

Unknown column 'ev9062555368' in 'where clause' (

which doesnt make much much sense because the column name is “event” and not “ev9062555368”

Any ideas?

tks 

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • it looks like you might be using the wrong type of quotes around ev9062555368. In the sample query you pasted it’s surrounded by backticks which will cause MySQL to treat this as an object (column/table) rather than a string. Using eventid LIKE 'ev9062555368' should sort it out.

    Like
Like Follow
  • 2 mths agoLast active
  • 1Replies
  • 10Views
  • 2 Following