mySQL concat if null drop literal

Question

I have a mySQL database that I am trying to get data from.

Here is my query:

"SELECT booking_number, customer_name, passenger_name, 
contact_phone, CONCAT(unit_number,'/', street_number, ' ', street_name, ', ', suburb) AS pickup_address, destination_suburb, pickup_datetime FROM $sql_table

If unit number is null I need to remove the literal '/'.

How can I do this?

ɹɐqʞɐ zoɹǝɟ · Accepted Answer · 2014-04-04 03:23:22Z

2

use it like this

CONCAT(unit_number, IF(unit_number IS NULL, '', '/'),street_number,.........

answered Apr 4, 2014 at 3:23

ɹɐqʞɐ zoɹǝɟ

4,3703 gold badges25 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

mySQL concat if null drop literal

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