Select from a field containing spaces using MySQL

Question

I'm attempting to query on a field/column/table in a MySQL DB where the field type is varchar, but some values contains spaces. In my query, I tried to put the exact string to match on in single quotes in a where clause. However, the only rows that are returned are the strings that do not contain spaces.

Here are the values stored in the table/column:

Here is the query and the result that is only returning fields without spaces:

I expected to find a row for "New Business", a row for "Monetary Endorsement", etc. Any idea on how I can modify my query to return the desired fields? Thanks for your help in advance!

John Woo · Accepted Answer · 2018-02-21 14:49:00Z

2

Maybe the other values have leading or trailing spaces. You can either use one of the suggestion below:

1.) Use TRIM()

WHERE TRIM(PTD_TRANS_TYPE) = 'NEW BUSINESS'

2.) Use LIKE

WHERE PTD_TRANS_TYPE LIKE '%NEW BUSINESS%'

Here's a Demo.

answered Feb 21, 2018 at 14:49

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select from a field containing spaces using MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related