How to get the value up to a specific character?

Question

PHP

Good afternoon, please advise me on this issue. There is a part of the query
LEFT JOIN main_color c ON m.color = c.color_en
But the problem is that for example in the color column the value can be Yelow / White, and in the color_en table it will be exclusively Yellow, respectively, the query does not find such a value. Is it possible to somehow form a request so that everything in m.color would be cut off before / and then compared with c.color_en?

Answer 1

LEFT JOIN main_color c ON m.color LIKE '%'+c.color_en+'%'

Finds both Yelow/White and White/Yelow and even Yelowpage (assuming c.color_en = Yelow)

what would cut everything in m.color up to / and then compare it with c.color_en?

If so, then:

LEFT JOIN main_color c ON m.color LIKE '%/'+c.color_en

In this case, it will only find White/Yelow
AND not find WhiteYelow