remove whitespaces on query mySQL

Question

Inside my database table called Postcodes I have rows like AB10 1AB, AB10 2AB

so when I'm pulling them to access a dynamic page they're appearing in the URL like AB10%201AB obviously because or being URL encoded, now how can I set the URL to just AB101AB and then still access the database row using AB101AB?

in brief, I want to access a row inside a database which has a value of AB10 1AB using AB101AB

something like

SELECT 
    * 
FROM 
    `Postcodes` 
WHERE 
    `postcode` = REMOVEWHITESPACES FROM `postcode` ROW('AB101AB')

possible duplicate of MySQL - how to remove white space in a mysql field — ChrisW
– ChrisW, Commented Sep 24, 2013 at 23:09

Barranka · Accepted Answer · 2013-09-24 23:07:27Z

1

Use the replace() function (reference here):

select *
from `Postcodes`
where replace(`postcode`, ' ', '') = 'AB101AB'

answered Sep 24, 2013 at 23:07

Barranka

21.1k14 gold badges72 silver badges89 bronze badges

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

Collectives™ on Stack Overflow

remove whitespaces on query mySQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related