Please follow the images,

Here the table verblist contains the value 'beat' in column baseVerb

But still on executing select query "SELECT * FROM datavaldb.verblist where baseVerb = 'beat';"

It is not returning anything. Any help?

enter image description here

put on hold as off-topic by sp_BlitzErik, RDFozz, hot2use, Tom V, LowlyDBA Nov 13 at 14:29

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – RDFozz, hot2use, LowlyDBA
If this question can be reworded to fit the rules in the help center, please edit the question.

  • What's your question? – mustaccio Nov 8 at 21:01
  • 1
    try with lwhere baseverb like 'beat%' or baseverb like '%beat%' – Sam Nov 8 at 21:01
  • @mustaccio my question is why is it not working? – Args Sarkar Nov 8 at 21:24
  • 1
    Why id column is missing?.Show me output of SELECT * FROM datavaldb.verblist WHERE verb1 LIKE '%beat%' – Sam Nov 8 at 22:27
  • 1
    Why don't you show me output of what I asked.If you have white spaces '%a' never works out. That's what Rick James is pointing out.Show me output of this "SELECT length(baseverb) len,length(trim(baseverb) trim,baseverb FROM verblist – Sam Nov 9 at 9:21

Browse other questions tagged or ask your own question.