简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Is there any way in Mysql to query a string inside another string?
ECHO
ECHO 2020-01-02 10:44:28
0
5
924

Mysql Is there any way to query? For example, the string '3,5' is within the string '3,4,5,2'

The situation is probably like this

How many users are there? An attribute, the attribute ID is stored in a field in the user table

For example, user_attr, the value storage format is: '3,4,5,2',

Explanation: For example, numbers are attributes ID

Now the front end needs to query �%9

ECHO
ECHO

reply all (4)
孤独是一种态度
孤独是一种态度2020-03-18 09:19:54 4 floor

find_in_set() Learn more

Like+0
Add Reply
    lk
    lk2020-01-15 18:29:13 3 floor

    like correct answer

    Like+0
    Add Reply
      junwind
      junwind2020-01-14 17:12:31 2 floor

      There is no need to use sql query here. Convert 3,5 passed from the front end into array [3,5], and then 3,4,5,2 are also converted into arrays. Compare them to know whether they are in it.

      Like+0
      Add Reply
        余水
        余水2020-01-03 00:31:25 1 floor

        Convert 3 and 5 into arrays, loop and splice where conditions, user_attr like '%3%' or user_attr like '%5%' groug by user id? Maybe the efficiency is not that high, it can be achieved

        Like+0
        Add Reply
        • reply If you use like, you can’t tell the difference between 3,13 5,15.
          ECHO author 2020-01-04 16:00:36
        Popular Topics
        More>
        Popular Articles
        Popular Tutorials
        More>
        Related Tutorials
        Popular Recommendations
        Latest courses
        Latest Downloads
        More>
        Web Effects
        Website Source Code
        Website Materials
        Front End Template
        About us Disclaimer Sitemap
        php.cn：Public welfare online PHP training，Help PHP learners grow quickly！