WordPress ( approx: 5.6 ) sqls to find all big data, ml, ai, related category ids (term ids)
SELECT wt.term_id FROM `wp_terms` wt
inner join wp_term_taxonomy wtt on (wtt.term_id = wt.term_id) and (wtt.taxonomy=’category’)
WHERE
(name like ‘%big data%’)
or ((name like ‘%cloud%’))
or ((name like ‘%machine learning%’))
or ((name like ‘%security%’))
or ((name like ‘AI’))
or (name like ‘%artificial intelligence%’)
or (name like ‘%data science%’)
or (name like ‘nlp’)
or (name like ‘%hadoop%’)
or (name like ‘%analytics%’)
or (name like ‘%business intelligence%’)
or (name like ‘BI’)
or (name like ‘%database%’)
or (name like ‘%DBMS%’)
or (name like ‘%data warehouse%’)
or (name like ‘%robotics%’)
or (name like ‘%visualization%’)
or (name like ‘%data visualization%’)
or (name like ‘%data mining%’)
or (name like ‘%graph minining%’)
or (name like ‘%optimization%’)
or (name like ‘%combinatorics%’)
or (name like ‘%hive%’)
or (name like ‘pig’)
or (name like ‘%spark%’)
or (name like ‘aws’)
or (name like ‘%elastic search%’)
or (name like ‘%bayesian%’)
or (name like ‘%tracking%’)
or (name like ‘%estimation%’)
or (name like ‘%deep learning%’)
or (name like ‘%reinforcement learning%’)
or (name like ‘%neural network%’)
or (name like ‘%natural language processing%’)
or (name like ‘%statistics%’)
or (name like ‘%algorithms for big data%’)
order by name
Note: All the or as used in the above could be simplified and/or made better in terms of syntax, easy of use, efficiency, extensibility. This is just quick.
*** . *** *** . *** . *** . ***
Courses: http://Training.SitesTree.com (Big Data, Cloud, Security, Machine Learning)
Blog: http://Bangla.SaLearningSchool.com, http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net
Shop Online: https://www.ShopForSoul.com/
Linkedin: https://ca.linkedin.com/in/sayedjustetc
